Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 6

In Excel intersection of a row and column is called :

a) Cata

b) A field.

c) A cell

d) An equation.

Question : 7

Which elements of a worksheet can be protected from accidental modification?

a) Contents

b) Objects

c) Scenarios

d) All of the above

e) None of these

Question : 8

In Excel to center worksheet titles across a range of cell, you must

a) Select the cells containing the title text and use the fill handle to center the text across a range of cells

b) Widen the columns

c) Select the cells containing the title text and use the fill handle to center the text across a range of cells

d) Widen the column

Question : 9

Comments can be added to cells using.....

a) Edit-> Comments

b) Insert •> Comment

c) Fl I e-> Comments

d) View-> Comments

e) None of these

Question : 10

How do you select an entire column?

a) Select Edit > Select > Column from the menu

b) Click the column heading letter

c) Hold down the shift key as you click anywhere in the column,

d) Hold down the Ctrl key as you click anywhere in the column

e) None of these